﻿INSERT INTO [dbo].[Enum_AddressType]([ID],[Value])VALUES('0','Unknown')
INSERT INTO [dbo].[Enum_AddressType]([ID],[Value])VALUES('1','Primary')
INSERT INTO [dbo].[Enum_AddressType]([ID],[Value])VALUES('2','Mailing')
INSERT INTO [dbo].[Enum_AddressType]([ID],[Value])VALUES('3','Other')
GO
INSERT INTO [dbo].[Enum_OrganisationType] ([ID],[Value]) VALUES ('0','Unknown')
INSERT INTO [dbo].[Enum_OrganisationType] ([ID],[Value]) VALUES ('1','Boarding')
INSERT INTO [dbo].[Enum_OrganisationType] ([ID],[Value]) VALUES ('2','Vet')
INSERT INTO [dbo].[Enum_OrganisationType] ([ID],[Value]) VALUES ('3','Sponsor')
INSERT INTO [dbo].[Enum_OrganisationType] ([ID],[Value]) VALUES ('4','Other')
GO
INSERT INTO [dbo].[Enum_EmailType] ([ID],[Value]) VALUES ('0','Unknown')
INSERT INTO [dbo].[Enum_EmailType] ([ID],[Value]) VALUES ('1','Home')
INSERT INTO [dbo].[Enum_EmailType] ([ID],[Value]) VALUES ('2','Work')
INSERT INTO [dbo].[Enum_EmailType] ([ID],[Value]) VALUES ('3','School')
INSERT INTO [dbo].[Enum_EmailType] ([ID],[Value]) VALUES ('4','Other')
GO
INSERT INTO [dbo].[Enum_PhoneType] ([ID],[Value]) VALUES ('0','Unknown')
INSERT INTO [dbo].[Enum_PhoneType] ([ID],[Value]) VALUES ('1','Home')
INSERT INTO [dbo].[Enum_PhoneType] ([ID],[Value]) VALUES ('2','Work')
INSERT INTO [dbo].[Enum_PhoneType] ([ID],[Value]) VALUES ('3','Mobile')
INSERT INTO [dbo].[Enum_PhoneType] ([ID],[Value]) VALUES ('4','Fax')
INSERT INTO [dbo].[Enum_PhoneType] ([ID],[Value]) VALUES ('5','Other')
GO
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Unknown','XX')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Alabama','AL')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Alaska','AK')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Arizona ','AZ')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Arkansas','AR')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('California ','CA')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Colorado','CO')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Connecticut','CT')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Delaware','DE')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('District Of Columbia','DC')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('FlorIDa','FL')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Georgia','GA')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Hawaii','HI')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Idaho','ID')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Illinois','IL')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Indiana','IN')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Iowa','IA')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Kansas','KS')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Kentucky','KY')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Louisiana','LA')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Maine','ME')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Maryland','MD')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Massachusetts','MA')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Michigan','MI')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Minnesota','MN')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Mississippi','MS')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Missouri','MO')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Montana','MT')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Nebraska','NE')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Nevada','NV')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('New Hampshire','NH')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('New Jersey','NJ')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('New Mexico','NM')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('New York','NY')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('North Carolina','NC')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('North Dakota','ND')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Ohio','OH')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Oklahoma','OK')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Oregon','OR')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Pennsylvania','PA')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Rhode Island','RI')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('South Carolina','SC')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('South Dakota','SD')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Tennessee','TN')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Texas','TX')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Utah','UT')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Vermont','VT')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Virginia','VA')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Washington','WA')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('West Virginia','WV')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Wisconsin','WI')
INSERT INTO [dbo].[Enum_UsaStates]([Value],[ID])VALUES('Wyoming','WY')
GO
INSERT INTO [dbo].[Enum_StudentType]([ID],[Value])VALUES('0','N/A')
INSERT INTO [dbo].[Enum_StudentType]([ID],[Value])VALUES('1','Full Time')
INSERT INTO [dbo].[Enum_StudentType]([ID],[Value])VALUES('2','Part Time')
GO
INSERT INTO [dbo].[Enum_ResidenceOwnershipType]([ID],[Value])VALUES('0','Unknown')
INSERT INTO [dbo].[Enum_ResidenceOwnershipType]([ID],[Value])VALUES('1','Own')
INSERT INTO [dbo].[Enum_ResidenceOwnershipType]([ID],[Value])VALUES('2','Rent')
GO
INSERT INTO [dbo].[Enum_ResidenceType]([ID],[Value])VALUES('0','Unknown')
INSERT INTO [dbo].[Enum_ResidenceType]([ID],[Value])VALUES('1','House')
INSERT INTO [dbo].[Enum_ResidenceType]([ID],[Value])VALUES('2','Apartment')
INSERT INTO [dbo].[Enum_ResidenceType]([ID],[Value])VALUES('3','Mobile Home')
INSERT INTO [dbo].[Enum_ResidenceType]([ID],[Value])VALUES('4','Duplex')
INSERT INTO [dbo].[Enum_ResidenceType]([ID],[Value])VALUES('5','Condo')
GO
INSERT INTO [dbo].[Enum_PetDepositCoverage]([ID],[Value])VALUES('0','Unknown')
INSERT INTO [dbo].[Enum_PetDepositCoverage]([ID],[Value])VALUES('1','per pet')
INSERT INTO [dbo].[Enum_PetDepositCoverage]([ID],[Value])VALUES('2','per household')
GO
INSERT INTO [dbo].[Enum_Gender]([ID],[Value])VALUES('1','Male')
INSERT INTO [dbo].[Enum_Gender]([ID],[Value])VALUES('2','Female')
GO
DBCC CHECKIDENT('[Enum_EventAttendeeType]', RESEED, -1)
INSERT INTO [dbo].[Enum_EventAttendeeType]([Value])VALUES('Unknown')
INSERT INTO [dbo].[Enum_EventAttendeeType]([Value])VALUES('Staff')
INSERT INTO [dbo].[Enum_EventAttendeeType]([Value])VALUES('Participant')
GO
INSERT INTO [dbo].[Enum_EventType]([ID],[Value])VALUES ('GLF','Golf Tournament')
INSERT INTO [dbo].[Enum_EventType]([ID],[Value])VALUES ('WSH','Dog Wash')
INSERT INTO [dbo].[Enum_EventType]([ID],[Value])VALUES ('OTH','Other')
GO
INSERT INTO [dbo].[Enum_Misc]([ID],[Value])VALUES('rescuecount','650')
GO
INSERT INTO [dbo].[Enum_Misc]([ID],[Value])VALUES('golfevent','00000000-0000-0000-0000-000000000000')
INSERT INTO [dbo].[Enum_Misc]([ID],[Value])VALUES('roughriderevent','00000000-0000-0000-0000-000000000000')
GO

INSERT INTO [dbo].[Enum_LogActivityEventType] ([Value]) VALUES ('CREATE')
INSERT INTO [dbo].[Enum_LogActivityEventType] ([Value]) VALUES ('DELETE-SOFT')
INSERT INTO [dbo].[Enum_LogActivityEventType] ([Value]) VALUES ('DELETE-HARD')
INSERT INTO [dbo].[Enum_LogActivityEventType] ([Value]) VALUES ('UPDATE')
INSERT INTO [dbo].[Enum_LogActivityEventType] ([Value]) VALUES ('GET-ONE')
INSERT INTO [dbo].[Enum_LogActivityEventType] ([Value]) VALUES ('GET-ALL')
GO

INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('AdoptionApp')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('AdoptionAppAnimal')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('AdoptionAppVet')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('BlogComment')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('BlogPost')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('BlogTag')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityAddress')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityBase')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityDog')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityDogIntake')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityDogPlacement')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityDonationItem')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityEmailAddress')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityFile')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityOrganisation')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityOrganisationContacts')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityOrganisationServices')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityPerson')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityPersonProfile')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityPersonSkills')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntityPhoneNumber')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntitySupplies')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntitySupplyPlacement')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EntitySupplyType')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EventAttendee')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EventRegistration')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EventSponsor')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EventSponsorshipLevel')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('EventSponsorshipLevelType')
INSERT INTO [dbo].[Enum_EntityType] ([Value]) VALUES ('Event')
GO

INSERT INTO [dbo].[Enum_Misc]([ID],[Value])VALUES('raffle','00000000-0000-0000-0000-000000000000')
GO

INSERT INTO [dbo].[System_ConfigCategory]([Name],[Description]) VALUES('general','General category for misc settings')
INSERT INTO [dbo].[System_ConfigCategory]([Name],[Description]) VALUES('email','All email related settings')
INSERT INTO [dbo].[System_ConfigCategory]([Name],[Description]) VALUES('braintree','BrainTree API payment settings')
INSERT INTO [dbo].[System_ConfigCategory]([Name],[Description]) VALUES('petfinder','PetFinder API settings')
INSERT INTO [dbo].[System_ConfigCategory]([Name],[Description]) VALUES('paths','Directory paths')
INSERT INTO [dbo].[System_ConfigCategory]([Name],[Description]) VALUES('rescuegroups','RescueGroups API settings')
INSERT INTO [dbo].[System_ConfigCategory]([Name],[Description]) VALUES('recaptcha','ReCaptcha API settings')
INSERT INTO [dbo].[System_ConfigCategory]([Name],[Description]) VALUES('google','Google API settings')
GO
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('general','TimeZone','Central Standard Time','Time Zone of the server')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('general','TimeZoneAbr','CST','Time Zone of the server')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','smtpFrom','web@texashuskyrescue.org','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','smtpNetworkHost','smtp.gmail.com','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','smptNetworkPort','587','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','smptNetworkEnableSsl','true','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','smptNetworkUserName','web@texashuskyrescue.org','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','smptNetworkPassword','c47fi5hing','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','adminEmail','web@texashuskyrescue.org','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','contactEmail','web@texashuskyrescue.org','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','fundraisingEmail','web@texashuskyrescue.org','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','golfEmail','web@texashuskyrescue.org','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','intakeEmail','web@texashuskyrescue.org','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','raffleEmail','web@texashuskyrescue.org','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('email','webEmail','web@texashuskyrescue.org','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('braintree','merchantID','sv97kx3h33r9g7xd','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('braintree','publicKey','8t8p2x7j2mm8cqr7','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('braintree','privateKey','c0d2f2b49050183746c590597a9c58a2','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('braintree','environment','SANDBOX','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('braintree','clientKey','MIIBCgKCAQEAmQJpwnH/7OETiyc0Ohdz9r/NPyq6iXRdzQqh7Reyn94DglLHgggSj6PMhpp12ENf1ZBT/gBrm+GBcm9lfPQoEG2QQjZOM6Lacs16SXyP3d105iCf7P6NsgjaI7awvXhvxrE1eXD7/Dzx15cwWNQoy/jeBCs3dM8NxvjVitf0ssADuYw7Qidsp2SC10GeoiTrw4l9Bn7aR42bvDlwU/1bsolFIK4Rns6eZzXkfLvJ+nZrcOruOyFMeHyJXg7YD0Fjduk7Vmy1Q6CrCgYcRiR20KugeVvF+qlthxBBwIMdH/DF9fvNuBEGkjHOZYclSvQUmsvPMOkkQ70+ofXJ4U+dHQIDAQAB','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('petfinder','apiKey','10e4ba235bc33bb0a548fe18c9e557f4','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('petfinder','apiSecretPhrase','460e99aa95c84a94a92fc0f9fa306dab','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('paths','adoptionApplicationLocation','/Forms/addoptionapplication.pdf','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('paths','fosterApplicationLocation','/Forms/fosterapplication.pdf','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('paths','pictureFolder','~\Pictures\','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('google','merchantID','557273504300865','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('google','merchantKey','1lDLgp_zYuCF4G09aptlag','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('google','environment','Sandbox','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('google','logging','true','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('google','currency','USD','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('rescuegroups','apiKey','c3Lhuc6b','The key is valid for both the REST and SOAP APIs. API Documentation: http://support.rescuegroups.org:8091/x/9YIO')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('recaptcha','publicKey','6LdZlt8SAAAAAFNr2_gJ-E-jB57p8J3FxCiputxE','')
INSERT INTO [dbo].[System_Config]([CategoryName],[Name],[Value],[Description])VALUES('recaptcha','privateKey','6LdZlt8SAAAAAFzt3c8ofJfCTcgmw5_mOtkBi3iC','')
GO
